<?php include_once "../../config.php" ; ?>
<?php
    $openid = $_REQUEST['openid'];
    //查找员工nid
    $employee_info=select_one_line_all_items($table_Prefix."employee","openid='".$openid."'");
    //查询该员工的超时任务
    $items = select_lines_all_items($table_Prefix."task","","status not in('待审核','已完成') and is_del = 0 and principal = ".$employee_info['nid']." and enddate < CURDATE()","");
?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <?php include ROOT_PATH_.'/controller/common/modules/head.php'; ?>
</head>
<body>
    <table class="layui-table">
        <thead>
            <tr>
                <th width="30">序号</th>
                <th>任务标题</th>
                <th width="60">截止时间</th>
            </tr>
        </thead>

            <tbody>
            <?php for($i = 0; $i < count($items); $i++){ ?>
                <tr>
                    <td><?php echo $i + 1; ?></td>
                    <td><?php echo $items[$i]['title']; ?></td>
                    <td><?php echo str_replace('-', '月', substr($items[$i]['enddate'],5,5)); ?>日</td>
                </tr>
            <?php } ?>
        </tbody>
    </table>
</body>
</html>
